
<html>

<head>

<title>...</title>

<meta http-equiv=Content-Type content=text/html; charset=iso-8859-1>

<link rel="stylesheet" type="text/css" href="../Css/main.css">
</head>


<SCRIPT LANGUAGE=javascript>
function button_over(b)
{
b.style.backgroundColor = '#B5BDD6';
b.style.borderColor = 'darkblue darkblue darkblue darkblue';
}
function button_out(b)
{
b.style.backgroundColor = 'threedface';
b.style.borderColor = 'threedface';
}
function button_down(b)
{
b.style.backgroundColor = '#8494B5';
b.style.borderColor = 'darkblue darkblue darkblue darkblue';
}
function button_up(b)
{
b.style.backgroundColor = '#B5BDD6';
b.style.borderColor = 'darkblue darkblue darkblue darkblue';
b = null;
}

function readall() {
}
</SCRIPT>




<body bgcolor='#ECE9D8'>

<table width=100% border=1 cellpadding=0 cellspacing=0 bordercolor='#000000' background='../imgsys/x.gif' bgcolor='#DEE2CB'>
  <tr> 
    <td valign=top align=center> <table width=100% border=0 cellspacing=0 cellpadding=0>
        <tr> 
          <td width='640' align=left><font color='#FFFFFF'><img src='../imgsys/add2.gif' width='21' height='18' border='0'>&nbsp;<strong>&nbsp;ADD 
            GOODTYPE</strong></font></td>
          <td width='640' align=center>&nbsp; </td>
          <td width='20' align=left bgcolor='#F0F2E6'><img src='../imgsys/bar.gif' border='0'></td>
          <td width='30' align=left bgcolor='#F0F2E6'><a href='UPD_GOODTYPE1.asp'><img src='../imgsys/edit.gif' alt='Edit data' width='21' height='18' border='0'></a></td>
          <td width='30' align=left bgcolor='#F0F2E6'><a href='INS_GOODTYPE1.asp'><img src='../imgsys/add.gif' alt='Add data' width='21' height='18' border='0'></a></td>
          <td width='10' align=left bgcolor='#F0F2E6'><img src='../imgsys/bar.gif' width='13' height='18' border='0'></td>
          <td width='30' align=center bgcolor='#F0F2E6'><a href='javascript:history.go(0)'><img src='../imgsys/refresh.gif' alt='Refresh' width='21' height='18' border='0'></a></td>
          <td width='30' align=center bgcolor='#F0F2E6'><a href='javascript:window.print();'><img src='../imgsys/printerbar.gif' alt='Print' width='19' height='20' border='0'></a></td>
          <td width='20' align=left bgcolor='#F0F2E6'><img src='../imgsys/bar.gif' width='13' height='18' border='0'></td>
          <td width='30' align=left bgcolor='#F0F2E6'><a href='javascript:window.location.href="right.htm"'><img src='../imgsys/close.gif' alt='Close form' width='15' height='16' border='0'></a></td>
        </tr>
      </table></td>
  </tr>
</table>


<table width=100% border=1 cellspacing=0 cellpadding=0 bordercolor=#000000>

<tr>

<td>

<table width=100% border=0 cellspacing=0 cellpadding=0>

<tr bgcolor='#DEE2CB'> 

<td>&nbsp;</td>

<td width='98%'>

<table width=100% border=0 cellspacing=0 cellpadding=0 bgcolor=#F0F2E6>

<Form name=frm method=POST action=INS_GOODTYPE2.asp>

<BR>

<tr> 

<td align=right valign=top><br><b>ID : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br><Input type=text name=F_ID size='98'></td>

</tr>

<tr> 

<td align=right valign=top><br><b>sub group of good : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br>

<%
'*****************************************************'
'           --  START CREATE  SET FIELD LINK   --     '
'                                                     '
'*****************************************************'

Dim conn2
Dim rs2
set conn2 = Server.Createobject("ADODB.Connection")
set  rs2 = Server.Createobject("ADODB.Recordset")
ConnStr2 = "DSN=dbpr_sql;UID=sa;PWD=hhhhhhhh;"
conn2.Mode = 3
conn2.Open (ConnStr2)
SQL2 = "SELECT * FROM SUBGROUPOFGOODS"
set rs2 = conn2.execute(SQL2)
%>
<select name=F_RF_GROUP_ID>

<%
Do While Not rs2.EOF
RESPONSE.WRITE("<option value=" & rs2.Fields("ID").value & ">" & rs2.Fields("NAME").value & "</option>")
rs2.MoveNext
Loop
%>
</select>

<%
conn2.close
set rs2 = Nothing
set conn2 = Nothing
'*****************************************************'
'           --  END CREATE  SET FIELD LINK   --       '
'                                                     '
'*****************************************************'
%>

</td>

</tr>

<tr> 

<td align=right valign=top><br><b>CODE : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br><Input type=text name=F_CODE size='98'></td>

</tr>

<tr> 

<td align=right valign=top><br><b>NAME : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br><Input type=text name=F_NAME size='98'></td>

</tr>

<tr> 

<td align=right valign=top><br><b>counting type : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br>

<%
'*****************************************************'
'           --  START CREATE  SET FIELD LINK   --     '
'                                                     '
'*****************************************************'

Dim conn5
Dim rs5
set conn5 = Server.Createobject("ADODB.Connection")
set  rs5 = Server.Createobject("ADODB.Recordset")
ConnStr5 = "DSN=dbpr_sql;UID=sa;PWD=hhhhhhhh;"
conn5.Mode = 3
conn5.Open (ConnStr5)
SQL5 = "SELECT * FROM COUNTINGTYPE"
set rs5 = conn5.execute(SQL5)
%>
<select name=F_RF_COUNTINGTYPE_ID>

<%
Do While Not rs5.EOF
RESPONSE.WRITE("<option value=" & rs5.Fields("ID").value & ">" & rs5.Fields("NAME").value & "</option>")
rs5.MoveNext
Loop
%>
</select>

<%
conn5.close
set rs5 = Nothing
set conn5 = Nothing
'*****************************************************'
'           --  END CREATE  SET FIELD LINK   --       '
'                                                     '
'*****************************************************'
%>

</td>

</tr>

<tr> 

<td align=right valign=top><br><b>TECHNICALNUMBER : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br><Input type=text name=F_TECHNICALNUMBER size='98'></td>

</tr>

<tr> 

<td align=right valign=top><br><b>TECHNICALDESC : </b>&nbsp;<img src='../imgsys/arrowt.gif' width='14' height='14'></td>

<td align=center valign=top><br><Input type=text name=F_TECHNICALDESC size='98'></td>

</tr>

<tr>

<td align=right valign=top>

<P>&nbsp;</P>

<P>&nbsp;</P>

</td>

<td align=center valign=top>

<P>&nbsp;</P>

<input type=reset value='Reset all data' class='submit'>

<input type=submit value='Save all data' class='submit' onClick='javascript: return readall()'>

<P>&nbsp;</P>

</td>

</tr>

</Form>

</table>

</td>

<td width=1%"&">&nbsp;</td>

</tr>

<tr bgcolor='#DEE2CB'> 

<td width=1%"&">&nbsp;</td>

<td width=98%"&">&nbsp;</td>

<td width=1%"&">&nbsp;</td>

</tr>

</table>

</td>

</tr>

</table>

<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td align=right>
<a href='http://www.codejay.com' class='codejay' target='_blank'>powered by codejay</a>
</td>
</tr>
</table>
</body>
</html>

